/*
 * Copyright 2000-2020 ALPHA LAB.Inc All Rights Reserved.
 */
package com.alphalab.framework.test.queryTest;

/**
 * ProjectItemQueryDaoConst.
 * @author allen 
 * @version 1.0.0 2017年12月26日
 */
public class ProjectItemQueryDaoConst {

	/**
	 * 防止实例化.
	* @param
	 */
	public ProjectItemQueryDaoConst() {
		
	} 

	/**
	 * 获取项目额外信息的sql.
	 */
	public static final String SQL_GET_PROJECTITEM_EXTENDLIST_BY_PROJECTID = ""
			+ "SELECT P.NAME AS PROJECTNAME ,U.NAME AS USERNAME "
			+ "FROM TEST_PROJECT P,SYS_USER U "
			+ "WHERE P.CREATEUSERID = U.ID AND P.ID = :PROJECTID";
	
	/**
	 * 获取项目信息的hql.
	 */
	public static final String SQL_GET_PROJECTITEM_LIST_BY_PROJECTID = ""
			+ "SELECT PI.NAME AS name , PI.DESCRIPTION AS description "
			+ "FROM TEST_PROJECT PI "
			+ "WHERE PI.ID IN (:PROJECTID)";	
	
}
